Proyecto 2 Profiling Report

Dataset statistics

Number of variables	27
Number of observations	1852394
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 GiB
Average record size in memory	958.0 B

Variable types

Categorical	13
Numeric	13
Boolean	1

Alerts

`trans_date_trans_time` has a high cardinality: 1819551 distinct values	High cardinality
`merchant` has a high cardinality: 693 distinct values	High cardinality
`first` has a high cardinality: 355 distinct values	High cardinality
`last` has a high cardinality: 486 distinct values	High cardinality
`street` has a high cardinality: 999 distinct values	High cardinality
`city` has a high cardinality: 906 distinct values	High cardinality
`state` has a high cardinality: 51 distinct values	High cardinality
`job` has a high cardinality: 497 distinct values	High cardinality
`dob` has a high cardinality: 984 distinct values	High cardinality
`trans_num` has a high cardinality: 1852394 distinct values	High cardinality
`zip` is highly overall correlated with `long` and 2 other fields	High correlation
`lat` is highly overall correlated with `merch_lat` and 1 other fields	High correlation
`long` is highly overall correlated with `zip` and 2 other fields	High correlation
`unix_time` is highly overall correlated with `first_time_at_merchant`	High correlation
`merch_lat` is highly overall correlated with `lat` and 1 other fields	High correlation
`merch_long` is highly overall correlated with `zip` and 2 other fields	High correlation
`amt_month` is highly overall correlated with `amt_month_shopping_net_spend` and 1 other fields	High correlation
`amt_month_shopping_net_spend` is highly overall correlated with `amt_month` and 1 other fields	High correlation
`count_month_shopping_net` is highly overall correlated with `amt_month` and 1 other fields	High correlation
`state` is highly overall correlated with `zip` and 4 other fields	High correlation
`first_time_at_merchant` is highly overall correlated with `unix_time`	High correlation
`is_fraud` is highly imbalanced (95.3%)	Imbalance
`amt` is highly skewed (γ1 = 40.81280918)	Skewed
`trans_date_trans_time` is uniformly distributed	Uniform
`trans_num` is uniformly distributed	Uniform
`trans_num` has unique values	Unique
`amt_month_shopping_net_spend` has 276206 (14.9%) zeros	Zeros
`count_month_shopping_net` has 276206 (14.9%) zeros	Zeros

Reproduction

Analysis started	2024-04-09 19:01:33.958561
Analysis finished	2024-04-09 19:05:06.989165
Duration	3 minutes and 33.03 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

trans_date_trans_time
Categorical

HIGH CARDINALITY UNIFORM

Distinct	1819551
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Memory size	134.3 MiB

2020-06-02 12:47:07	4
2019-04-22 16:02:01	4
2020-10-05 19:37:49	4
2020-06-01 01:37:47	4
2020-12-17 20:36:39	4
Other values (1819546)	1852374

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	35195486
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1787218 ?
Unique (%)	96.5%

Sample

1st row	2019-01-01 00:00:18
2nd row	2019-01-01 00:00:44
3rd row	2019-01-01 00:00:51
4th row	2019-01-01 00:01:16
5th row	2019-01-01 00:03:06

Common Values

Value	Count	Frequency (%)
2020-06-02 12:47:07	4	< 0.1%
2019-04-22 16:02:01	4	< 0.1%
2020-10-05 19:37:49	4	< 0.1%
2020-06-01 01:37:47	4	< 0.1%
2020-12-17 20:36:39	4	< 0.1%
2020-12-13 17:53:47	4	< 0.1%
2020-12-19 16:02:22	4	< 0.1%
2020-06-16 21:07:32	3	< 0.1%
2020-03-29 15:19:49	3	< 0.1%
2020-12-06 13:06:24	3	< 0.1%
Other values (1819541)	1852357	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-11-30	6530	0.2%
2020-12-07	6506	0.2%
2019-12-08	6428	0.2%
2019-12-15	6425	0.2%
2020-12-14	6400	0.2%
2020-12-21	6390	0.2%
2019-12-22	6325	0.2%
2020-12-28	6321	0.2%
2019-12-29	6320	0.2%
2019-12-01	6283	0.2%
Other values (87120)	3640860	98.3%

Most occurring characters

Value	Count	Frequency (%)
0	6745202	19.2%
2	5566647	15.8%
1	4622458	13.1%
-	3704788	10.5%
:	3704788	10.5%
	1852394	5.3%
9	1767840	5.0%
3	1661287	4.7%
5	1467022	4.2%
4	1457257	4.1%
Other values (3)	2645803	7.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	25933516	73.7%
Dash Punctuation	3704788	10.5%
Other Punctuation	3704788	10.5%
Space Separator	1852394	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6745202	26.0%
2	5566647	21.5%
1	4622458	17.8%
9	1767840	6.8%
3	1661287	6.4%
5	1467022	5.7%
4	1457257	5.6%
8	887465	3.4%
7	880319	3.4%
6	878019	3.4%

Dash Punctuation

Value	Count	Frequency (%)
-	3704788	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	3704788	100.0%

Space Separator

Value	Count	Frequency (%)
	1852394	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	35195486	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6745202	19.2%
2	5566647	15.8%
1	4622458	13.1%
-	3704788	10.5%
:	3704788	10.5%
	1852394	5.3%
9	1767840	5.0%
3	1661287	4.7%
5	1467022	4.2%
4	1457257	4.1%
Other values (3)	2645803	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35195486	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6745202	19.2%
2	5566647	15.8%
1	4622458	13.1%
-	3704788	10.5%
:	3704788	10.5%
	1852394	5.3%
9	1767840	5.0%
3	1661287	4.7%
5	1467022	4.2%
4	1457257	4.1%
Other values (3)	2645803	7.5%

cc_num
Real number (ℝ)

Distinct	999
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1738604 × 10¹⁷

Minimum	6.0416207 × 10¹⁰
Maximum	4.9923464 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	6.0416207 × 10¹⁰
5-th percentile	6.3048488 × 10¹¹
Q1	1.8004295 × 10¹⁴
median	3.5214173 × 10¹⁵
Q3	4.6422555 × 10¹⁵
95-th percentile	4.497914 × 10¹⁸
Maximum	4.9923464 × 10¹⁸
Range	4.9923463 × 10¹⁸
Interquartile range (IQR)	4.4622125 × 10¹⁵

Descriptive statistics

Standard deviation	1.3091153 × 10¹⁸
Coefficient of variation (CV)	3.1364616
Kurtosis	6.1753558
Mean	4.1738604 × 10¹⁷
Median Absolute Deviation (MAD)	3.0764709 × 10¹⁵
Skewness	2.8510736
Sum	5.0088429 × 10¹⁸
Variance	1.7137828 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.538441737 × 10¹⁵	4392	0.2%
3.02704321 × 10¹³	4392	0.2%
6.538891243 × 10¹⁵	4386	0.2%
4.364010865 × 10¹⁵	4386	0.2%
4.642255475 × 10¹⁵	4386	0.2%
6.011438889 × 10¹⁵	4385	0.2%
3.447098678 × 10¹⁴	4385	0.2%
4.904681492 × 10¹⁵	4384	0.2%
4.586810169 × 10¹⁵	4384	0.2%
4.512828415 × 10¹⁸	4384	0.2%
Other values (989)	1808530	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.041620718 × 10¹⁰	2196	0.1%
6.042292873 × 10¹⁰	2200	0.1%
6.042309813 × 10¹⁰	738	< 0.1%
6.042785159 × 10¹⁰	743	< 0.1%
6.048700208 × 10¹⁰	735	< 0.1%
6.04905963 × 10¹⁰	1465	0.1%
6.049559311 × 10¹⁰	742	< 0.1%
5.018029536 × 10¹¹	2194	0.1%
5.018181333 × 10¹¹	8	< 0.1%
5.018282048 × 10¹¹	733	< 0.1%

Value	Count	Frequency (%)
4.992346398 × 10¹⁸	2922	0.2%
4.989847571 × 10¹⁸	1471	0.1%
4.980323468 × 10¹⁸	736	< 0.1%
4.973530368 × 10¹⁸	1467	0.1%
4.958589672 × 10¹⁸	2191	0.1%
4.95682899 × 10¹⁸	3657	0.2%
4.911818931 × 10¹⁸	9	< 0.1%
4.906628656 × 10¹⁸	3655	0.2%
4.897067971 × 10¹⁸	1471	0.1%
4.890424427 × 10¹⁸	2189	0.1%

merchant
Categorical

Distinct	693
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	141.6 MiB

fraud_Kilback LLC	6262
fraud_Cormier LLC	5246
fraud_Schumm PLC	5195
fraud_Kuhn LLC	5031
fraud_Boyer PLC	4999
Other values (688)	1825661

Length

Max length	43
Median length	36
Mean length	23.130553
Min length	13

Characters and Unicode

Total characters	42846898
Distinct characters	55
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	fraud_Rippin, Kub and Mann
2nd row	fraud_Heller, Gutmann and Zieme
3rd row	fraud_Lind-Buckridge
4th row	fraud_Kutch, Hermiston and Farrell
5th row	fraud_Keeling-Crist

Common Values

Value	Count	Frequency (%)
fraud_Kilback LLC	6262	0.3%
fraud_Cormier LLC	5246	0.3%
fraud_Schumm PLC	5195	0.3%
fraud_Kuhn LLC	5031	0.3%
fraud_Boyer PLC	4999	0.3%
fraud_Dickinson Ltd	4953	0.3%
fraud_Emard Inc	3867	0.2%
fraud_Cummerata-Jones	3860	0.2%
fraud_Corwin-Collins	3853	0.2%
fraud_Rodriguez Group	3843	0.2%
Other values (683)	1805285	97.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	677362	15.7%
llc	139662	3.2%
inc	131148	3.0%
sons	104651	2.4%
ltd	100896	2.3%
plc	94799	2.2%
group	72089	1.7%
fraud_kutch	15028	0.3%
fraud_schaefer	13367	0.3%
fraud_streich	13235	0.3%
Other values (804)	2956186	68.5%

Most occurring characters

Value	Count	Frequency (%)
a	4158232	9.7%
r	3851348	9.0%
d	3055994	7.1%
e	2665745	6.2%
u	2654462	6.2%
n	2526397	5.9%
	2466029	5.8%
f	1996096	4.7%
_	1852394	4.3%
o	1614017	3.8%
Other values (45)	16006184	37.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	32423363	75.7%
Uppercase Letter	4854354	11.3%
Space Separator	2466029	5.8%
Connector Punctuation	1852394	4.3%
Dash Punctuation	636438	1.5%
Other Punctuation	614320	1.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4158232	12.8%
r	3851348	11.9%
d	3055994	9.4%
e	2665745	8.2%
u	2654462	8.2%
n	2526397	7.8%
f	1996096	6.2%
o	1614017	5.0%
i	1542189	4.8%
t	1247340	3.8%
Other values (15)	7111543	21.9%

Uppercase Letter

Value	Count	Frequency (%)
L	681216	14.0%
C	445751	9.2%
S	430704	8.9%
B	398258	8.2%
H	372874	7.7%
K	309458	6.4%
G	274723	5.7%
R	259594	5.3%
M	255426	5.3%
P	227921	4.7%
Other values (15)	1198429	24.7%

Other Punctuation

Value	Count	Frequency (%)
,	572711	93.2%
'	41609	6.8%

Space Separator

Value	Count	Frequency (%)
	2466029	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1852394	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	636438	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37277717	87.0%
Common	5569181	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4158232	11.2%
r	3851348	10.3%
d	3055994	8.2%
e	2665745	7.2%
u	2654462	7.1%
n	2526397	6.8%
f	1996096	5.4%
o	1614017	4.3%
i	1542189	4.1%
t	1247340	3.3%
Other values (40)	11965897	32.1%

Common

Value	Count	Frequency (%)
	2466029	44.3%
_	1852394	33.3%
-	636438	11.4%
,	572711	10.3%
'	41609	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42846898	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	4158232	9.7%
r	3851348	9.0%
d	3055994	7.1%
e	2665745	6.2%
u	2654462	6.2%
n	2526397	5.9%
	2466029	5.8%
f	1996096	4.7%
_	1852394	4.3%
o	1614017	3.8%
Other values (45)	16006184	37.4%

category
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.3 MiB

gas_transport	188029
grocery_pos	176191
home	175460
shopping_pos	166463
kids_pets	161727
Other values (9)	984524

Length

Max length	14
Median length	12
Mean length	10.525913
Min length	4

Characters and Unicode

Total characters	19498139
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	misc_net
2nd row	grocery_pos
3rd row	entertainment
4th row	gas_transport
5th row	misc_pos

Common Values

Value	Count	Frequency (%)
gas_transport	188029	10.2%
grocery_pos	176191	9.5%
home	175460	9.5%
shopping_pos	166463	9.0%
kids_pets	161727	8.7%
shopping_net	139322	7.5%
entertainment	134118	7.2%
food_dining	130729	7.1%
personal_care	130085	7.0%
health_fitness	122553	6.6%
Other values (4)	327717	17.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gas_transport	188029	10.2%
grocery_pos	176191	9.5%
home	175460	9.5%
shopping_pos	166463	9.0%
kids_pets	161727	8.7%
shopping_net	139322	7.5%
entertainment	134118	7.2%
food_dining	130729	7.1%
personal_care	130085	7.0%
health_fitness	122553	6.6%
Other values (4)	327717	17.7%

Most occurring characters

Value	Count	Frequency (%)
s	2042254	10.5%
e	1838696	9.4%
o	1758769	9.0%
n	1705118	8.7%
p	1548294	7.9%
t	1538055	7.9%
_	1484860	7.6%
r	1310440	6.7%
i	1190524	6.1%
a	950855	4.9%
Other values (10)	4130274	21.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18013279	92.4%
Connector Punctuation	1484860	7.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	2042254	11.3%
e	1838696	10.2%
o	1758769	9.8%
n	1705118	9.5%
p	1548294	8.6%
t	1538055	8.5%
r	1310440	7.3%
i	1190524	6.6%
a	950855	5.3%
g	865612	4.8%
Other values (9)	3264662	18.1%

Connector Punctuation

Value	Count	Frequency (%)
_	1484860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18013279	92.4%
Common	1484860	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	2042254	11.3%
e	1838696	10.2%
o	1758769	9.8%
n	1705118	9.5%
p	1548294	8.6%
t	1538055	8.5%
r	1310440	7.3%
i	1190524	6.6%
a	950855	5.3%
g	865612	4.8%
Other values (9)	3264662	18.1%

Common

Value	Count	Frequency (%)
_	1484860	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19498139	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	2042254	10.5%
e	1838696	9.4%
o	1758769	9.0%
n	1705118	8.7%
p	1548294	7.9%
t	1538055	7.9%
_	1484860	7.6%
r	1310440	6.7%
i	1190524	6.1%
a	950855	4.9%
Other values (10)	4130274	21.2%

amt
Real number (ℝ)

Distinct	60616
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.063567

Minimum	1
Maximum	28948.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2.44
Q1	9.64
median	47.45
Q3	83.1
95-th percentile	195.34
Maximum	28948.9
Range	28947.9
Interquartile range (IQR)	73.46

Descriptive statistics

Standard deviation	159.25397
Coefficient of variation (CV)	2.2729927
Kurtosis	4181.9073
Mean	70.063567
Median Absolute Deviation (MAD)	37.46
Skewness	40.812809
Sum	1.2978533 × 10⁸
Variance	25361.828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.14	779	< 0.1%
1.1	745	< 0.1%
1.04	744	< 0.1%
1.08	741	< 0.1%
1.2	737	< 0.1%
1.25	737	< 0.1%
1.02	736	< 0.1%
1.01	735	< 0.1%
1.22	727	< 0.1%
1.03	726	< 0.1%
Other values (60606)	1844987	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	332	< 0.1%
1.01	735	< 0.1%
1.02	736	< 0.1%
1.03	726	< 0.1%
1.04	744	< 0.1%
1.05	721	< 0.1%
1.06	671	< 0.1%
1.07	723	< 0.1%
1.08	741	< 0.1%
1.09	720	< 0.1%

Value	Count	Frequency (%)
28948.9	1	< 0.1%
27390.12	1	< 0.1%
27119.77	1	< 0.1%
26544.12	1	< 0.1%
25086.94	1	< 0.1%
22768.11	1	< 0.1%
21437.71	1	< 0.1%
19364.91	1	< 0.1%
17897.24	1	< 0.1%
16837.08	1	< 0.1%

first
Categorical

Distinct	355
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.4 MiB

Christopher	38112
Robert	30743
Jessica	29236
David	28564
Michael	28539
Other values (350)	1697200

Length

Max length	11
Median length	9
Mean length	6.0802977
Min length	3

Characters and Unicode

Total characters	11263107
Distinct characters	49
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jennifer
2nd row	Stephanie
3rd row	Edward
4th row	Jeremy
5th row	Tyler

Common Values

Value	Count	Frequency (%)
Christopher	38112	2.1%
Robert	30743	1.7%
Jessica	29236	1.6%
David	28564	1.5%
Michael	28539	1.5%
James	28496	1.5%
Jennifer	24181	1.3%
John	23445	1.3%
Mary	23424	1.3%
William	23396	1.3%
Other values (345)	1574258	85.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
christopher	38112	2.1%
robert	30743	1.7%
jessica	29236	1.6%
david	28564	1.5%
michael	28539	1.5%
james	28496	1.5%
jennifer	24181	1.3%
john	23445	1.3%
mary	23424	1.3%
william	23396	1.3%
Other values (345)	1574258	85.0%

Most occurring characters

Value	Count	Frequency (%)
a	1438618	12.8%
e	1230164	10.9%
i	883628	7.8%
n	877668	7.8%
r	867952	7.7%
l	554750	4.9%
h	493347	4.4%
s	463151	4.1%
t	444904	4.0%
o	384330	3.4%
Other values (39)	3624595	32.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9410713	83.6%
Uppercase Letter	1852394	16.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1438618	15.3%
e	1230164	13.1%
i	883628	9.4%
n	877668	9.3%
r	867952	9.2%
l	554750	5.9%
h	493347	5.2%
s	463151	4.9%
t	444904	4.7%
o	384330	4.1%
Other values (16)	1772201	18.8%

Uppercase Letter

Value	Count	Frequency (%)
J	312497	16.9%
M	207053	11.2%
S	163822	8.8%
A	161026	8.7%
C	151594	8.2%
D	123025	6.6%
K	122133	6.6%
R	100327	5.4%
T	95095	5.1%
L	89957	4.9%
Other values (13)	325865	17.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11263107	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1438618	12.8%
e	1230164	10.9%
i	883628	7.8%
n	877668	7.8%
r	867952	7.7%
l	554750	4.9%
h	493347	4.4%
s	463151	4.1%
t	444904	4.0%
o	384330	3.4%
Other values (39)	3624595	32.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11263107	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1438618	12.8%
e	1230164	10.9%
i	883628	7.8%
n	877668	7.8%
r	867952	7.7%
l	554750	4.9%
h	493347	4.4%
s	463151	4.1%
t	444904	4.0%
o	384330	3.4%
Other values (39)	3624595	32.2%

last
Categorical

Distinct	486
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.5 MiB

Smith	40940
Williams	33661
Davis	31434
Johnson	28590
Rodriguez	24879
Other values (481)	1692890

Length

Max length	11
Median length	10
Mean length	6.1123751
Min length	2

Characters and Unicode

Total characters	11322527
Distinct characters	48
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Banks
2nd row	Gill
3rd row	Sanchez
4th row	White
5th row	Garcia

Common Values

Value	Count	Frequency (%)
Smith	40940	2.2%
Williams	33661	1.8%
Davis	31434	1.7%
Johnson	28590	1.5%
Rodriguez	24879	1.3%
Martinez	21246	1.1%
Jones	19825	1.1%
Lewis	18293	1.0%
Miller	16821	0.9%
Gonzalez	16809	0.9%
Other values (476)	1599896	86.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
smith	40940	2.2%
williams	33661	1.8%
davis	31434	1.7%
johnson	28590	1.5%
rodriguez	24879	1.3%
martinez	21246	1.1%
jones	19825	1.1%
lewis	18293	1.0%
miller	16821	0.9%
gonzalez	16809	0.9%
Other values (476)	1599896	86.4%

Most occurring characters

Value	Count	Frequency (%)
e	1122673	9.9%
r	941641	8.3%
a	926704	8.2%
n	869662	7.7%
o	832319	7.4%
l	698286	6.2%
s	696904	6.2%
i	622878	5.5%
t	412730	3.6%
h	327959	2.9%
Other values (38)	3870771	34.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9470133	83.6%
Uppercase Letter	1852394	16.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1122673	11.9%
r	941641	9.9%
a	926704	9.8%
n	869662	9.2%
o	832319	8.8%
l	698286	7.4%
s	696904	7.4%
i	622878	6.6%
t	412730	4.4%
h	327959	3.5%
Other values (15)	2018377	21.3%

Uppercase Letter

Value	Count	Frequency (%)
M	226754	12.2%
W	152268	8.2%
S	150041	8.1%
C	133108	7.2%
B	120068	6.5%
R	118650	6.4%
H	116343	6.3%
G	108329	5.8%
J	102555	5.5%
P	94463	5.1%
Other values (13)	529815	28.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11322527	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1122673	9.9%
r	941641	8.3%
a	926704	8.2%
n	869662	7.7%
o	832319	7.4%
l	698286	6.2%
s	696904	6.2%
i	622878	5.5%
t	412730	3.6%
h	327959	2.9%
Other values (38)	3870771	34.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11322527	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1122673	9.9%
r	941641	8.3%
a	926704	8.2%
n	869662	7.7%
o	832319	7.4%
l	698286	6.2%
s	696904	6.2%
i	622878	5.5%
t	412730	3.6%
h	327959	2.9%
Other values (38)	3870771	34.2%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	102.5 MiB

F	1014749
M	837645

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1852394
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	F
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	1014749	54.8%
m	837645	45.2%

Most occurring characters

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1852394	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1852394	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1852394	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

street
Categorical

Distinct	999
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.0 MiB

444 Robert Mews	4392
908 Brooks Brook	4392
5796 Lee Coves Apt. 286	4386
03512 Jackson Ports	4386
320 Nicholson Orchard	4386
Other values (994)	1830452

Length

Max length	35
Median length	29
Mean length	22.231289
Min length	12

Characters and Unicode

Total characters	41181107
Distinct characters	62
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	561 Perry Cove
2nd row	43039 Riley Greens Suite 393
3rd row	594 White Dale Suite 530
4th row	9443 Cynthia Court Apt. 038
5th row	408 Bradley Rest

Common Values

Value	Count	Frequency (%)
444 Robert Mews	4392	0.2%
908 Brooks Brook	4392	0.2%
5796 Lee Coves Apt. 286	4386	0.2%
03512 Jackson Ports	4386	0.2%
320 Nicholson Orchard	4386	0.2%
40624 Rebecca Spurs	4385	0.2%
2924 Bobby Trafficway	4385	0.2%
574 David Locks Suite 207	4384	0.2%
6983 Carrillo Isle	4384	0.2%
864 Reynolds Plains	4384	0.2%
Other values (989)	1808530	97.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
apt	468297	6.4%
suite	437016	5.9%
island	32903	0.4%
michael	27058	0.4%
islands	25611	0.3%
station	25602	0.3%
common	25585	0.3%
david	24853	0.3%
brooks	24143	0.3%
fields	23400	0.3%
Other values (1959)	6253340	84.9%

Most occurring characters

Value	Count	Frequency (%)
	5515414	13.4%
e	2561201	6.2%
a	2077034	5.0%
i	1851621	4.5%
t	1782137	4.3%
r	1576757	3.8%
n	1523518	3.7%
s	1476954	3.6%
l	1270600	3.1%
o	1251043	3.0%
Other values (52)	20294828	49.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	20590784	50.0%
Decimal Number	9996511	24.3%
Space Separator	5515414	13.4%
Uppercase Letter	4610101	11.2%
Other Punctuation	468297	1.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2561201	12.4%
a	2077034	10.1%
i	1851621	9.0%
t	1782137	8.7%
r	1576757	7.7%
n	1523518	7.4%
s	1476954	7.2%
l	1270600	6.2%
o	1251043	6.1%
u	877146	4.3%
Other values (16)	4342773	21.1%

Uppercase Letter

Value	Count	Frequency (%)
S	802997	17.4%
A	602938	13.1%
M	368232	8.0%
C	319120	6.9%
P	279598	6.1%
R	266324	5.8%
B	212130	4.6%
F	204980	4.4%
L	188044	4.1%
J	173487	3.8%
Other values (14)	1192251	25.9%

Decimal Number

Value	Count	Frequency (%)
5	1069201	10.7%
3	1058055	10.6%
2	1049445	10.5%
7	1003976	10.0%
1	990872	9.9%
8	988888	9.9%
6	968316	9.7%
0	967826	9.7%
4	958817	9.6%
9	941115	9.4%

Space Separator

Value	Count	Frequency (%)
	5515414	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	468297	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25200885	61.2%
Common	15980222	38.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2561201	10.2%
a	2077034	8.2%
i	1851621	7.3%
t	1782137	7.1%
r	1576757	6.3%
n	1523518	6.0%
s	1476954	5.9%
l	1270600	5.0%
o	1251043	5.0%
u	877146	3.5%
Other values (40)	8952874	35.5%

Common

Value	Count	Frequency (%)
	5515414	34.5%
5	1069201	6.7%
3	1058055	6.6%
2	1049445	6.6%
7	1003976	6.3%
1	990872	6.2%
8	988888	6.2%
6	968316	6.1%
0	967826	6.1%
4	958817	6.0%
Other values (2)	1409412	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41181107	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5515414	13.4%
e	2561201	6.2%
a	2077034	5.0%
i	1851621	4.5%
t	1782137	4.3%
r	1576757	3.8%
n	1523518	3.7%
s	1476954	3.6%
l	1270600	3.1%
o	1251043	3.0%
Other values (52)	20294828	49.3%

city
Categorical

Distinct	906
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	116.0 MiB

Birmingham	8040
San Antonio	7312
Utica	7309
Phoenix	7297
Meridian	7289
Other values (901)	1815147

Length

Max length	25
Median length	21
Mean length	8.6526209
Min length	3

Characters and Unicode

Total characters	16028063
Distinct characters	52
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moravian Falls
2nd row	Orient
3rd row	Malad City
4th row	Boulder
5th row	Doe Hill

Common Values

Value	Count	Frequency (%)
Birmingham	8040	0.4%
San Antonio	7312	0.4%
Utica	7309	0.4%
Phoenix	7297	0.4%
Meridian	7289	0.4%
Warren	6584	0.4%
Conway	6574	0.4%
Cleveland	6572	0.4%
Thomas	6571	0.4%
Houston	5865	0.3%
Other values (896)	1782981	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
city	30780	1.3%
west	27847	1.2%
saint	20483	0.9%
north	20472	0.9%
falls	18286	0.8%
new	16857	0.7%
mount	16098	0.7%
lake	16089	0.7%
san	14638	0.6%
springs	12414	0.5%
Other values (929)	2118136	91.6%

Most occurring characters

Value	Count	Frequency (%)
e	1555978	9.7%
a	1334959	8.3%
n	1173952	7.3%
o	1168590	7.3%
l	1115539	7.0%
r	1070587	6.7%
i	1007053	6.3%
t	855511	5.3%
s	637587	4.0%
	459706	2.9%
Other values (42)	5648601	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13253329	82.7%
Uppercase Letter	2313564	14.4%
Space Separator	459706	2.9%
Dash Punctuation	1464	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1555978	11.7%
a	1334959	10.1%
n	1173952	8.9%
o	1168590	8.8%
l	1115539	8.4%
r	1070587	8.1%
i	1007053	7.6%
t	855511	6.5%
s	637587	4.8%
d	441997	3.3%
Other values (15)	2891576	21.8%

Uppercase Letter

Value	Count	Frequency (%)
C	224081	9.7%
M	211444	9.1%
S	193942	8.4%
B	190231	8.2%
H	165364	7.1%
W	136180	5.9%
P	131749	5.7%
L	123697	5.3%
R	113410	4.9%
A	106896	4.6%
Other values (15)	716570	31.0%

Space Separator

Value	Count	Frequency (%)
	459706	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1464	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15566893	97.1%
Common	461170	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1555978	10.0%
a	1334959	8.6%
n	1173952	7.5%
o	1168590	7.5%
l	1115539	7.2%
r	1070587	6.9%
i	1007053	6.5%
t	855511	5.5%
s	637587	4.1%
d	441997	2.8%
Other values (40)	5205140	33.4%

Common

Value	Count	Frequency (%)
	459706	99.7%
-	1464	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16028063	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1555978	9.7%
a	1334959	8.3%
n	1173952	7.3%
o	1168590	7.3%
l	1115539	7.0%
r	1070587	6.7%
i	1007053	6.3%
t	855511	5.3%
s	637587	4.0%
	459706	2.9%
Other values (42)	5648601	35.2%

state
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	104.2 MiB

TX	135269
NY	119419
PA	114173
CA	80495
OH	66627
Other values (46)	1336411

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3704788
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NC
2nd row	WA
3rd row	ID
4th row	MT
5th row	VA

Common Values

Value	Count	Frequency (%)
TX	135269	7.3%
NY	119419	6.4%
PA	114173	6.2%
CA	80495	4.3%
OH	66627	3.6%
MI	65825	3.6%
IL	62212	3.4%
FL	60775	3.3%
AL	58521	3.2%
MO	54904	3.0%
Other values (41)	1034174	55.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tx	135269	7.3%
ny	119419	6.4%
pa	114173	6.2%
ca	80495	4.3%
oh	66627	3.6%
mi	65825	3.6%
il	62212	3.4%
fl	60775	3.3%
al	58521	3.2%
mo	54904	3.0%
Other values (41)	1034174	55.8%

Most occurring characters

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3704788	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3704788	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3704788	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

zip
Real number (ℝ)

Distinct	985
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48813.258

Minimum	1257
Maximum	99921
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1257
5-th percentile	7208
Q1	26237
median	48174
Q3	72042
95-th percentile	94569
Maximum	99921
Range	98664
Interquartile range (IQR)	45805

Descriptive statistics

Standard deviation	26881.846
Coefficient of variation (CV)	0.55070788
Kurtosis	-1.0960542
Mean	48813.258
Median Absolute Deviation (MAD)	23068
Skewness	0.078949647
Sum	9.0421387 × 10¹⁰
Variance	7.2263364 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82514	5116	0.3%
73754	5116	0.3%
48088	5115	0.3%
34112	5108	0.3%
61454	4392	0.2%
16114	4392	0.2%
89512	4386	0.2%
72476	4386	0.2%
84540	4386	0.2%
72042	4385	0.2%
Other values (975)	1805612	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1257	2923	0.2%
1330	1466	0.1%
1535	734	< 0.1%
1545	1468	0.1%
1612	738	< 0.1%
1843	3652	0.2%
1844	2919	0.2%
2180	738	< 0.1%
2630	2924	0.2%
2908	745	< 0.1%

Value	Count	Frequency (%)
99921	14	< 0.1%
99783	2203	0.1%
99747	12	< 0.1%
99746	734	< 0.1%
99323	3651	0.2%
99160	4362	0.2%
99116	15	< 0.1%
99113	1463	0.1%
99033	3646	0.2%
98836	740	< 0.1%

lat
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.539311

Minimum	20.0271
Maximum	66.6933
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	20.0271
5-th percentile	29.8826
Q1	34.6689
median	39.3543
Q3	41.9404
95-th percentile	45.8433
Maximum	66.6933
Range	46.6662
Interquartile range (IQR)	7.2715

Descriptive statistics

Standard deviation	5.0714704
Coefficient of variation (CV)	0.13159214
Kurtosis	0.79107707
Mean	38.539311
Median Absolute Deviation (MAD)	3.3597
Skewness	-0.19199899
Sum	71389988
Variance	25.719812
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36.385	5116	0.3%
43.0048	5116	0.3%
42.5164	5115	0.3%
26.1184	5108	0.3%
40.6761	4392	0.2%
41.3851	4392	0.2%
39.5483	4386	0.2%
38.9999	4386	0.2%
36.0244	4386	0.2%
34.2853	4385	0.2%
Other values (973)	1805612	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.0271	2186	0.1%
20.0827	1463	0.1%
24.6557	3655	0.2%
26.1184	5108	0.3%
26.3304	741	< 0.1%
26.3771	732	< 0.1%
26.4215	4362	0.2%
26.4722	3650	0.2%
26.529	2202	0.1%
26.6939	1467	0.1%

Value	Count	Frequency (%)
66.6933	12	< 0.1%
65.6899	734	< 0.1%
64.7556	2203	0.1%
55.4732	14	< 0.1%
48.8878	4362	0.2%
48.8856	2909	0.2%
48.8328	2200	0.1%
48.6669	1469	0.1%
48.6031	4376	0.2%
48.4786	2916	0.2%

long
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.227832

Minimum	-165.6723
Maximum	-67.9503
Zeros	0
Zeros (%)	0.0%
Negative	1852394
Negative (%)	100.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	-165.6723
5-th percentile	-119.0825
Q1	-96.798
median	-87.4769
Q3	-80.158
95-th percentile	-73.5365
Maximum	-67.9503
Range	97.722
Interquartile range (IQR)	16.64

Descriptive statistics

Standard deviation	13.747895
Coefficient of variation (CV)	-0.15236867
Kurtosis	1.8375586
Mean	-90.227832
Median Absolute Deviation (MAD)	8.1527
Skewness	-1.1469188
Sum	-1.671375 × 10⁸
Variance	189.00461
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-98.0727	5116	0.3%
-108.8964	5116	0.3%
-82.9832	5115	0.3%
-81.7361	5108	0.3%
-91.0391	4392	0.2%
-80.1752	4392	0.2%
-82.7243	4391	0.2%
-109.615	4386	0.2%
-90.9288	4386	0.2%
-119.7957	4386	0.2%
Other values (973)	1805606	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-165.6723	2203	0.1%
-156.292	734	< 0.1%
-155.488	1463	0.1%
-155.3697	2186	0.1%
-153.994	12	< 0.1%
-133.1171	14	< 0.1%
-124.4409	1467	0.1%
-124.2174	2195	0.1%
-124.1587	1465	0.1%
-124.1437	2198	0.1%

Value	Count	Frequency (%)
-67.9503	2922	0.2%
-68.5565	1467	0.1%
-69.2675	743	< 0.1%
-69.4828	2931	0.2%
-69.9576	737	< 0.1%
-69.9656	4374	0.2%
-70.1031	9	< 0.1%
-70.239	1455	0.1%
-70.3001	2924	0.2%
-70.3457	2196	0.1%

city_pop
Real number (ℝ)

Distinct	891
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88643.675

Minimum	23
Maximum	2906700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	23
5-th percentile	139
Q1	741
median	2443
Q3	20328
95-th percentile	525713
Maximum	2906700
Range	2906677
Interquartile range (IQR)	19587

Descriptive statistics

Standard deviation	301487.62
Coefficient of variation (CV)	3.4011182
Kurtosis	37.572846
Mean	88643.675
Median Absolute Deviation (MAD)	2188
Skewness	5.5908046
Sum	1.6420301 × 10¹¹
Variance	9.0894784 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
606	8049	0.4%
1595797	7312	0.4%
1312922	7297	0.4%
241	6578	0.4%
1766	6556	0.4%
2906700	5865	0.3%
302	5853	0.3%
198	5850	0.3%
276002	5849	0.3%
1126	5841	0.3%
Other values (881)	1787344	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
23	2915	0.2%
37	1469	0.1%
43	2920	0.2%
46	4386	0.2%
47	734	< 0.1%
49	1472	0.1%
51	1470	0.1%
52	740	< 0.1%
53	3660	0.2%
60	1472	0.1%

Value	Count	Frequency (%)
2906700	5865	0.3%
2504700	2929	0.2%
2383912	737	< 0.1%
1595797	7312	0.4%
1577385	3680	0.2%
1526206	5113	0.3%
1417793	8	< 0.1%
1382480	2913	0.2%
1312922	7297	0.4%
1263321	5141	0.3%

job
Categorical

Distinct	497
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	136.4 MiB

Film/video editor	13898
Exhibition designer	13167
Surveyor, land/geomatics	12436
Naval architect	12434
Materials engineer	11711
Other values (492)	1788748

Length

Max length	59
Median length	38
Mean length	20.232398
Min length	3

Characters and Unicode

Total characters	37478372
Distinct characters	53
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Psychologist, counselling
2nd row	Special educational needs teacher
3rd row	Nature conservation officer
4th row	Patent attorney
5th row	Dance movement psychotherapist

Common Values

Value	Count	Frequency (%)
Film/video editor	13898	0.8%
Exhibition designer	13167	0.7%
Surveyor, land/geomatics	12436	0.7%
Naval architect	12434	0.7%
Materials engineer	11711	0.6%
Designer, ceramics/pottery	11688	0.6%
Environmental consultant	10974	0.6%
Financial adviser	10963	0.6%
Systems developer	10962	0.6%
IT trainer	10943	0.6%
Other values (487)	1733218	93.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
engineer	188048	4.6%
officer	158202	3.8%
manager	87837	2.1%
scientist	79740	1.9%
designer	74639	1.8%
surveyor	70288	1.7%
teacher	54865	1.3%
psychologist	46856	1.1%
research	42426	1.0%
editor	40958	1.0%
Other values (457)	3270295	79.5%

Most occurring characters

Value	Count	Frequency (%)
e	4003951	10.7%
i	3407729	9.1%
r	3140909	8.4%
a	2593110	6.9%
t	2547852	6.8%
n	2521475	6.7%
	2261760	6.0%
o	2133314	5.7%
s	2064644	5.5%
c	1890653	5.0%
Other values (43)	10912975	29.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	32557679	86.9%
Space Separator	2261760	6.0%
Uppercase Letter	1956330	5.2%
Other Punctuation	633855	1.7%
Close Punctuation	34374	0.1%
Open Punctuation	34374	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4003951	12.3%
i	3407729	10.5%
r	3140909	9.6%
a	2593110	8.0%
t	2547852	7.8%
n	2521475	7.7%
o	2133314	6.6%
s	2064644	6.3%
c	1890653	5.8%
l	1428836	4.4%
Other values (16)	6825206	21.0%

Uppercase Letter

Value	Count	Frequency (%)
C	224603	11.5%
E	207826	10.6%
P	204864	10.5%
S	196162	10.0%
T	161692	8.3%
M	127340	6.5%
A	126006	6.4%
F	98100	5.0%
D	82672	4.2%
R	79744	4.1%
Other values (11)	447321	22.9%

Other Punctuation

Value	Count	Frequency (%)
,	446459	70.4%
/	176367	27.8%
'	11029	1.7%

Space Separator

Value	Count	Frequency (%)
	2261760	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	34374	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	34374	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	34514009	92.1%
Common	2964363	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4003951	11.6%
i	3407729	9.9%
r	3140909	9.1%
a	2593110	7.5%
t	2547852	7.4%
n	2521475	7.3%
o	2133314	6.2%
s	2064644	6.0%
c	1890653	5.5%
l	1428836	4.1%
Other values (37)	8781536	25.4%

Common

Value	Count	Frequency (%)
	2261760	76.3%
,	446459	15.1%
/	176367	5.9%
)	34374	1.2%
(	34374	1.2%
'	11029	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37478372	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	4003951	10.7%
i	3407729	9.1%
r	3140909	8.4%
a	2593110	6.9%
t	2547852	6.8%
n	2521475	6.7%
	2261760	6.0%
o	2133314	5.7%
s	2064644	5.5%
c	1890653	5.0%
Other values (43)	10912975	29.1%

dob
Categorical

Distinct	984
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	118.4 MiB

1977-03-23	8044
1988-09-15	6574
1981-08-29	6571
1955-05-06	5121
1960-01-13	4395
Other values (979)	1821689

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	18523940
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1988-03-09
2nd row	1978-06-21
3rd row	1962-01-19
4th row	1967-01-12
5th row	1986-03-28

Common Values

Value	Count	Frequency (%)
1977-03-23	8044	0.4%
1988-09-15	6574	0.4%
1981-08-29	6571	0.4%
1955-05-06	5121	0.3%
1960-01-13	4395	0.2%
1972-11-28	4392	0.2%
1997-09-22	4392	0.2%
1997-03-12	4386	0.2%
1987-04-23	4386	0.2%
1993-04-08	4385	0.2%
Other values (974)	1799748	97.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1977-03-23	8044	0.4%
1988-09-15	6574	0.4%
1981-08-29	6571	0.4%
1955-05-06	5121	0.3%
1960-01-13	4395	0.2%
1997-09-22	4392	0.2%
1972-11-28	4392	0.2%
1997-03-12	4386	0.2%
1987-04-23	4386	0.2%
1993-04-08	4385	0.2%
Other values (974)	1799748	97.2%

Most occurring characters

Value	Count	Frequency (%)
-	3704788	20.0%
1	3546230	19.1%
9	2637517	14.2%
0	2559962	13.8%
2	1291776	7.0%
7	950290	5.1%
8	921815	5.0%
6	782368	4.2%
5	765535	4.1%
3	691719	3.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14819152	80.0%
Dash Punctuation	3704788	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	3546230	23.9%
9	2637517	17.8%
0	2559962	17.3%
2	1291776	8.7%
7	950290	6.4%
8	921815	6.2%
6	782368	5.3%
5	765535	5.2%
3	691719	4.7%
4	671940	4.5%

Dash Punctuation

Value	Count	Frequency (%)
-	3704788	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18523940	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	3704788	20.0%
1	3546230	19.1%
9	2637517	14.2%
0	2559962	13.8%
2	1291776	7.0%
7	950290	5.1%
8	921815	5.0%
6	782368	4.2%
5	765535	4.1%
3	691719	3.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18523940	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	3704788	20.0%
1	3546230	19.1%
9	2637517	14.2%
0	2559962	13.8%
2	1291776	7.0%
7	950290	5.1%
8	921815	5.0%
6	782368	4.2%
5	765535	4.1%
3	691719	3.7%

trans_num
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	1852394
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	157.2 MiB

0b242abb623afc578575680df30655b9	1
ad44105b2defec28687e0c0c00db0dd2	1
fff81009b323191d0a427a2af21e5bc7	1
2341854d7594722011878c08ba3819dd	1
f7f00d638b16a8b1045d8a8978b607bd	1
Other values (1852389)	1852389

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	59276608
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1852394 ?
Unique (%)	100.0%

Sample

1st row	0b242abb623afc578575680df30655b9
2nd row	1f76529f8574734946361c461b024d99
3rd row	a1a22d70485983eac12b5b88dad1cf95
4th row	6b849c168bdad6f867558c3793159a81
5th row	a41d7549acf90789359a9aa5346dcb46

Common Values

Value	Count	Frequency (%)
0b242abb623afc578575680df30655b9	1	< 0.1%
ad44105b2defec28687e0c0c00db0dd2	1	< 0.1%
fff81009b323191d0a427a2af21e5bc7	1	< 0.1%
2341854d7594722011878c08ba3819dd	1	< 0.1%
f7f00d638b16a8b1045d8a8978b607bd	1	< 0.1%
fd51c30194494698905af5871aa6cc15	1	< 0.1%
67ac45826276ec940cfbc0de6a19c501	1	< 0.1%
8c95f2a0927c7c65bfa4dbb18d31d36b	1	< 0.1%
f44fb23e29d805a76b54dcdfb0e4e755	1	< 0.1%
9589fd1bdbed3034eea19e0cdeefdc15	1	< 0.1%
Other values (1852384)	1852384	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0b242abb623afc578575680df30655b9	1	< 0.1%
0189da32192f942196b01f50bcebeac8	1	< 0.1%
189a841a0a8ba03058526bcfe566aab5	1	< 0.1%
83ec1cc84142af6e2acf10c44949e720	1	< 0.1%
6d294ed2cc447d2c71c7171a3d54967c	1	< 0.1%
fc28024ce480f8ef21a32d64c93a29f5	1	< 0.1%
3b9014ea8fb80bd65de0b1463b00b00e	1	< 0.1%
d71c95ab6b7356dd74389d41df429c87	1	< 0.1%
3c74776e558f1499a7824b556e474b1d	1	< 0.1%
c1d9a7ddb1e34639fe82758de97f4abf	1	< 0.1%
Other values (1852384)	1852384	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
9	3708557	6.3%
4	3707696	6.3%
7	3707599	6.3%
2	3707045	6.3%
3	3706132	6.3%
1	3705118	6.3%
d	3704966	6.3%
a	3704452	6.2%
8	3704258	6.2%
c	3703707	6.2%
Other values (6)	22217078	37.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37055836	62.5%
Lowercase Letter	22220772	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	3708557	10.0%
4	3707696	10.0%
7	3707599	10.0%
2	3707045	10.0%
3	3706132	10.0%
1	3705118	10.0%
8	3704258	10.0%
6	3703446	10.0%
5	3703001	10.0%
0	3702984	10.0%

Lowercase Letter

Value	Count	Frequency (%)
d	3704966	16.7%
a	3704452	16.7%
c	3703707	16.7%
f	3703143	16.7%
e	3702587	16.7%
b	3701917	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	37055836	62.5%
Latin	22220772	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	3708557	10.0%
4	3707696	10.0%
7	3707599	10.0%
2	3707045	10.0%
3	3706132	10.0%
1	3705118	10.0%
8	3704258	10.0%
6	3703446	10.0%
5	3703001	10.0%
0	3702984	10.0%

Latin

Value	Count	Frequency (%)
d	3704966	16.7%
a	3704452	16.7%
c	3703707	16.7%
f	3703143	16.7%
e	3702587	16.7%
b	3701917	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59276608	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	3708557	6.3%
4	3707696	6.3%
7	3707599	6.3%
2	3707045	6.3%
3	3706132	6.3%
1	3705118	6.3%
d	3704966	6.3%
a	3704452	6.2%
8	3704258	6.2%
c	3703707	6.2%
Other values (6)	22217078	37.5%

unix_time
Real number (ℝ)

Distinct	1819583
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3586742 × 10⁹

Minimum	1.325376 × 10⁹
Maximum	1.3885344 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1.325376 × 10⁹
5-th percentile	1.3300982 × 10⁹
Q1	1.3430168 × 10⁹
median	1.3570893 × 10⁹
Q3	1.3745815 × 10⁹
95-th percentile	1.3867821 × 10⁹
Maximum	1.3885344 × 10⁹
Range	63158356
Interquartile range (IQR)	31564662

Descriptive statistics

Standard deviation	18195081
Coefficient of variation (CV)	0.013391791
Kurtosis	-1.1995793
Mean	1.3586742 × 10⁹
Median Absolute Deviation (MAD)	15789076
Skewness	-0.019735681
Sum	2.5168 × 10¹⁵
Variance	3.3106099 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1387312599	4	< 0.1%
1387468942	4	< 0.1%
1381001869	4	< 0.1%
1335110521	4	< 0.1%
1386957227	4	< 0.1%
1370177227	4	< 0.1%
1370050667	4	< 0.1%
1335729039	3	< 0.1%
1339879107	3	< 0.1%
1387727516	3	< 0.1%
Other values (1819573)	1852357	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1325376018	1	< 0.1%
1325376044	1	< 0.1%
1325376051	1	< 0.1%
1325376076	1	< 0.1%
1325376186	1	< 0.1%
1325376248	1	< 0.1%
1325376282	1	< 0.1%
1325376308	1	< 0.1%
1325376318	1	< 0.1%
1325376361	1	< 0.1%

Value	Count	Frequency (%)
1388534374	1	< 0.1%
1388534364	1	< 0.1%
1388534355	1	< 0.1%
1388534349	1	< 0.1%
1388534347	1	< 0.1%
1388534314	1	< 0.1%
1388534284	1	< 0.1%
1388534276	1	< 0.1%
1388534270	1	< 0.1%
1388534238	1	< 0.1%

merch_lat
Real number (ℝ)

Distinct	1754157
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.538976

Minimum	19.027422
Maximum	67.510267
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	19.027422
5-th percentile	29.753795
Q1	34.740122
median	39.3689
Q3	41.956263
95-th percentile	46.002013
Maximum	67.510267
Range	48.482845
Interquartile range (IQR)	7.2161407

Descriptive statistics

Standard deviation	5.1056039
Coefficient of variation (CV)	0.13247897
Kurtosis	0.77423362
Mean	38.538976
Median Absolute Deviation (MAD)	3.38992
Skewness	-0.1880969
Sum	71389368
Variance	26.067191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.363447	4	< 0.1%
38.164527	4	< 0.1%
36.545289	4	< 0.1%
40.822878	4	< 0.1%
39.779565	4	< 0.1%
43.272992	4	< 0.1%
41.829986	4	< 0.1%
40.557026	4	< 0.1%
39.115059	4	< 0.1%
39.818513	4	< 0.1%
Other values (1754147)	1852354	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.027422	1	< 0.1%
19.027785	1	< 0.1%
19.027804	1	< 0.1%
19.027849	1	< 0.1%
19.029798	1	< 0.1%
19.031242	1	< 0.1%
19.032277	1	< 0.1%
19.032689	1	< 0.1%
19.033288	1	< 0.1%
19.034282	1	< 0.1%

Value	Count	Frequency (%)
67.510267	1	< 0.1%
67.441518	1	< 0.1%
67.397018	1	< 0.1%
67.188111	1	< 0.1%
67.064277	1	< 0.1%
66.835174	1	< 0.1%
66.682905	1	< 0.1%
66.679297	1	< 0.1%
66.674714	1	< 0.1%
66.67355	1	< 0.1%

merch_long
Real number (ℝ)

Distinct	1809753
Distinct (%)	97.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.22794

Minimum	-166.67157
Maximum	-66.950902
Zeros	0
Zeros (%)	0.0%
Negative	1852394
Negative (%)	100.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	-166.67157
5-th percentile	-119.30928
Q1	-96.89944
median	-87.440694
Q3	-80.245108
95-th percentile	-73.365169
Maximum	-66.950902
Range	99.720673
Interquartile range (IQR)	16.654332

Descriptive statistics

Standard deviation	13.759692
Coefficient of variation (CV)	-0.15249924
Kurtosis	1.8312584
Mean	-90.22794
Median Absolute Deviation (MAD)	8.2235005
Skewness	-1.143933
Sum	-1.6713769 × 10⁸
Variance	189.32913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-96.511763	4	< 0.1%
-81.995265	4	< 0.1%
-74.433003	4	< 0.1%
-81.036745	4	< 0.1%
-73.900295	4	< 0.1%
-95.822621	4	< 0.1%
-74.618269	4	< 0.1%
-87.830842	4	< 0.1%
-80.940524	4	< 0.1%
-79.147111	4	< 0.1%
Other values (1809743)	1852354	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-166.671575	1	< 0.1%
-166.671242	1	< 0.1%
-166.670685	1	< 0.1%
-166.670132	1	< 0.1%
-166.670006	1	< 0.1%
-166.66991	1	< 0.1%
-166.669812	1	< 0.1%
-166.669638	1	< 0.1%
-166.666179	1	< 0.1%
-166.664828	1	< 0.1%

Value	Count	Frequency (%)
-66.950902	1	< 0.1%
-66.952026	1	< 0.1%
-66.952352	1	< 0.1%
-66.955602	1	< 0.1%
-66.955996	1	< 0.1%
-66.95654	1	< 0.1%
-66.957364	1	< 0.1%
-66.958659	1	< 0.1%
-66.958751	1	< 0.1%
-66.959178	1	< 0.1%

is_fraud
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	102.5 MiB

0	1842743
1	9651

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1852394
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring characters

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1852394	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	1852394	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1852394	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

amt_month
Real number (ℝ)

Distinct	896534
Distinct (%)	48.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4153.689

Minimum	1
Maximum	43261.89
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1
5-th percentile	251.28
Q1	1344.79
median	3071.99
Q3	5738.47
95-th percentile	11792.017
Maximum	43261.89
Range	43260.89
Interquartile range (IQR)	4393.68

Descriptive statistics

Standard deviation	3909.0054
Coefficient of variation (CV)	0.94109246
Kurtosis	6.2031988
Mean	4153.689
Median Absolute Deviation (MAD)	2005.26
Skewness	1.9707692
Sum	7.6942686 × 10⁹
Variance	15280323
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.15	15	< 0.1%
7.31	15	< 0.1%
5.29	15	< 0.1%
9.12	14	< 0.1%
8.95	14	< 0.1%
9.46	14	< 0.1%
1.07	14	< 0.1%
381.05	13	< 0.1%
1016.18	13	< 0.1%
251.87	13	< 0.1%
Other values (896524)	1852254	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
1.01	8	< 0.1%
1.02	9	< 0.1%
1.03	7	< 0.1%
1.04	6	< 0.1%
1.05	5	< 0.1%
1.06	6	< 0.1%
1.07	14	< 0.1%
1.08	9	< 0.1%
1.09	8	< 0.1%

Value	Count	Frequency (%)
43261.89	1	< 0.1%
43055.12	1	< 0.1%
43047.94	1	< 0.1%
43013.27	1	< 0.1%
42923.81	1	< 0.1%
42917.54	1	< 0.1%
42887.02	1	< 0.1%
42841.05	1	< 0.1%
42818.8	1	< 0.1%
42750.39	1	< 0.1%

amt_year
Real number (ℝ)

Distinct	1694572
Distinct (%)	91.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45305.597

Minimum	1.02
Maximum	219086.77
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1.02
5-th percentile	3283.553
Q1	17341.423
median	37439.105
Q3	64720.88
95-th percentile	115831.99
Maximum	219086.77
Range	219085.75
Interquartile range (IQR)	47379.458

Descriptive statistics

Standard deviation	35867.522
Coefficient of variation (CV)	0.79167972
Kurtosis	1.4120611
Mean	45305.597
Median Absolute Deviation (MAD)	22656.73
Skewness	1.1686746
Sum	8.3923817 × 10¹⁰
Variance	1.2864792 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5468.43	6	< 0.1%
33774.13	5	< 0.1%
12498.63	5	< 0.1%
18523.06	5	< 0.1%
8598.52	5	< 0.1%
19724.97	5	< 0.1%
10775.67	5	< 0.1%
43987.25	5	< 0.1%
15209.24	5	< 0.1%
5724.87	5	< 0.1%
Other values (1694562)	1852343	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.02	1	< 0.1%
1.03	1	< 0.1%
1.04	1	< 0.1%
1.07	1	< 0.1%
1.08	1	< 0.1%
1.13	2	< 0.1%
1.15	1	< 0.1%
1.19	1	< 0.1%
1.2	2	< 0.1%
1.21	1	< 0.1%

Value	Count	Frequency (%)
219086.77	1	< 0.1%
219073.58	1	< 0.1%
219025.18	1	< 0.1%
218957.58	1	< 0.1%
218955.06	1	< 0.1%
218941.76	1	< 0.1%
218866.61	1	< 0.1%
218824.2	1	< 0.1%
218743.75	1	< 0.1%
218713.06	1	< 0.1%

amt_month_shopping_net_spend
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	73861
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	376.2028

Minimum	0
Maximum	12047.18
Zeros	276206
Zeros (%)	14.9%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	9.02
median	75.89
Q3	425.98
95-th percentile	1717.35
Maximum	12047.18
Range	12047.18
Interquartile range (IQR)	416.96

Descriptive statistics

Standard deviation	725.35307
Coefficient of variation (CV)	1.9280906
Kurtosis	23.999749
Mean	376.2028
Median Absolute Deviation (MAD)	75.89
Skewness	4.0224138
Sum	6.9687581 × 10⁸
Variance	526137.08
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	276206	14.9%
9.12	575	< 0.1%
9.89	528	< 0.1%
9.35	475	< 0.1%
9.52	469	< 0.1%
4.49	465	< 0.1%
9.2	451	< 0.1%
4.93	448	< 0.1%
7.85	436	< 0.1%
3.17	434	< 0.1%
Other values (73851)	1571907	84.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	276206	14.9%
1	28	< 0.1%
1.01	418	< 0.1%
1.02	278	< 0.1%
1.03	238	< 0.1%
1.04	269	< 0.1%
1.05	285	< 0.1%
1.06	178	< 0.1%
1.07	269	< 0.1%
1.08	316	< 0.1%

Value	Count	Frequency (%)
12047.18	15	< 0.1%
10812.12	3	< 0.1%
10805.83	5	< 0.1%
10796.17	28	< 0.1%
10790.23	3	< 0.1%
10339.78	2	< 0.1%
10245.7	11	< 0.1%
10242.58	1	< 0.1%
10238.88	12	< 0.1%
10235.86	12	< 0.1%

count_month_shopping_net
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5672411

Minimum	0
Maximum	48
Zeros	276206
Zeros (%)	14.9%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	7
95-th percentile	14
Maximum	48
Range	48
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.5755024
Coefficient of variation (CV)	1.0018088
Kurtosis	4.3978581
Mean	4.5672411
Median Absolute Deviation (MAD)	2
Skewness	1.7306414
Sum	8460330
Variance	20.935222
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	276206	14.9%
1	268131	14.5%
2	227701	12.3%
3	196162	10.6%
4	161418	8.7%
5	135485	7.3%
6	114389	6.2%
7	94026	5.1%
8	76806	4.1%
9	62216	3.4%
Other values (39)	239854	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	276206	14.9%
1	268131	14.5%
2	227701	12.3%
3	196162	10.6%
4	161418	8.7%
5	135485	7.3%
6	114389	6.2%
7	94026	5.1%
8	76806	4.1%
9	62216	3.4%

Value	Count	Frequency (%)
48	9	< 0.1%
47	8	< 0.1%
46	6	< 0.1%
45	6	< 0.1%
44	7	< 0.1%
43	7	< 0.1%
42	20	< 0.1%
41	33	< 0.1%
40	53	< 0.1%
39	40	< 0.1%

first_time_at_merchant
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

False	1323066
True	529328

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1323066	71.4%
True	529328	28.6%

Auto

Heatmap
Table

	cc_num	amt	zip	lat	long	city_pop	unix_time	merch_lat	merch_long	amt_month	amt_year	amt_month_shopping_net_spend	count_month_shopping_net	category	gender	state	is_fraud	first_time_at_merchant
cc_num	1.000	-0.001	0.013	-0.003	-0.013	0.049	0.001	-0.003	-0.013	0.008	0.011	0.010	0.017	0.008	0.052	0.238	0.003	0.019
amt	-0.001	1.000	0.001	0.013	-0.000	-0.024	-0.001	0.013	-0.000	0.061	0.037	0.081	-0.010	0.019	0.001	0.003	0.000	0.005
zip	0.013	0.001	1.000	-0.162	-0.959	-0.040	0.001	-0.162	-0.957	0.017	0.017	0.025	0.029	0.011	0.116	0.963	0.004	0.025
lat	-0.003	0.013	-0.162	1.000	0.105	-0.264	0.001	0.991	0.104	-0.012	-0.012	-0.005	-0.009	0.010	0.101	0.748	0.038	0.027
long	-0.013	-0.000	-0.959	0.105	1.000	0.087	-0.001	0.105	0.998	-0.011	-0.010	-0.017	-0.026	0.009	0.091	0.863	0.038	0.016
city_pop	0.049	-0.024	-0.040	-0.264	0.087	1.000	-0.003	-0.263	0.086	0.013	0.020	-0.002	-0.022	0.014	0.090	0.313	0.002	0.024
unix_time	0.001	-0.001	0.001	0.001	-0.001	-0.003	1.000	0.001	-0.001	0.129	0.396	0.084	0.117	0.001	0.000	0.003	0.022	0.509
merch_lat	-0.003	0.013	-0.162	0.991	0.105	-0.263	0.001	1.000	0.104	-0.012	-0.012	-0.004	-0.009	0.011	0.103	0.759	0.038	0.020
merch_long	-0.013	-0.000	-0.957	0.104	0.998	0.086	-0.001	0.104	1.000	-0.011	-0.010	-0.017	-0.026	0.009	0.083	0.829	0.038	0.013
amt_month	0.008	0.061	0.017	-0.012	-0.011	0.013	0.129	-0.012	-0.011	1.000	0.472	0.732	0.821	0.016	0.106	0.055	0.030	0.167
amt_year	0.011	0.037	0.017	-0.012	-0.010	0.020	0.396	-0.012	-0.010	0.472	1.000	0.348	0.422	0.020	0.146	0.083	0.036	0.351
amt_month_shopping_net_spend	0.010	0.081	0.025	-0.005	-0.017	-0.002	0.084	-0.004	-0.017	0.732	0.348	1.000	0.777	0.014	0.091	0.051	0.091	0.065
count_month_shopping_net	0.017	-0.010	0.029	-0.009	-0.026	-0.022	0.117	-0.009	-0.026	0.821	0.422	0.777	1.000	0.023	0.125	0.055	0.014	0.169
category	0.008	0.019	0.011	0.010	0.009	0.014	0.001	0.011	0.009	0.016	0.020	0.014	0.023	1.000	0.054	0.019	0.067	0.139
gender	0.052	0.001	0.116	0.101	0.091	0.090	0.000	0.103	0.083	0.106	0.146	0.091	0.125	0.054	1.000	0.256	0.006	0.044
state	0.238	0.003	0.963	0.748	0.863	0.313	0.003	0.759	0.829	0.055	0.083	0.051	0.055	0.019	0.256	1.000	0.033	0.058
is_fraud	0.003	0.000	0.004	0.038	0.038	0.002	0.022	0.038	0.038	0.030	0.036	0.091	0.014	0.067	0.006	0.033	1.000	0.028
first_time_at_merchant	0.019	0.005	0.025	0.027	0.016	0.024	0.509	0.020	0.013	0.167	0.351	0.065	0.169	0.139	0.044	0.058	0.028	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long	amt_month	amt_year	first_time_at_merchant
0	2019-01-01 00:00:18	2703186189652095	fraud_Rippin, Kub and Mann	misc_net	4.97	Jennifer	Banks	F	561 Perry Cove	Moravian Falls	NC	28654	36.0788	-81.1781	3495	Psychologist, counselling	1988-03-09	0b242abb623afc578575680df30655b9	1325376018	36.011293	-82.048315	4.97	4.97	True
1	2019-01-01 00:00:44	630423337322	fraud_Heller, Gutmann and Zieme	grocery_pos	107.23	Stephanie	Gill	F	43039 Riley Greens Suite 393	Orient	WA	99160	48.8878	-118.2105	149	Special educational needs teacher	1978-06-21	1f76529f8574734946361c461b024d99	1325376044	49.159047	-118.186462	107.23	107.23	True
2	2019-01-01 00:00:51	38859492057661	fraud_Lind-Buckridge	entertainment	220.11	Edward	Sanchez	M	594 White Dale Suite 530	Malad City	ID	83252	42.1808	-112.2620	4154	Nature conservation officer	1962-01-19	a1a22d70485983eac12b5b88dad1cf95	1325376051	43.150704	-112.154481	220.11	220.11	True
3	2019-01-01 00:01:16	3534093764340240	fraud_Kutch, Hermiston and Farrell	gas_transport	45.00	Jeremy	White	M	9443 Cynthia Court Apt. 038	Boulder	MT	59632	46.2306	-112.1138	1939	Patent attorney	1967-01-12	6b849c168bdad6f867558c3793159a81	1325376076	47.034331	-112.561071	45.00	45.00	True
4	2019-01-01 00:03:06	375534208663984	fraud_Keeling-Crist	misc_pos	41.96	Tyler	Garcia	M	408 Bradley Rest	Doe Hill	VA	24433	38.4207	-79.4629	99	Dance movement psychotherapist	1986-03-28	a41d7549acf90789359a9aa5346dcb46	1325376186	38.674999	-78.632459	41.96	41.96	True
5	2019-01-01 00:04:08	4767265376804500	fraud_Stroman, Hudson and Erdman	gas_transport	94.63	Jennifer	Conner	F	4655 David Island	Dublin	PA	18917	40.3750	-75.2045	2158	Transport planner	1961-06-19	189a841a0a8ba03058526bcfe566aab5	1325376248	40.653382	-76.152667	94.63	94.63	True
6	2019-01-01 00:04:42	30074693890476	fraud_Rowe-Vandervort	grocery_net	44.54	Kelsey	Richards	F	889 Sarah Station Suite 624	Holcomb	KS	67851	37.9931	-100.9893	2691	Arboriculturist	1993-08-16	83ec1cc84142af6e2acf10c44949e720	1325376282	37.162705	-100.153370	44.54	44.54	True
7	2019-01-01 00:05:08	6011360759745864	fraud_Corwin-Collins	gas_transport	71.65	Steven	Williams	M	231 Flores Pass Suite 720	Edinburg	VA	22824	38.8432	-78.6003	6018	Designer, multimedia	1947-08-21	6d294ed2cc447d2c71c7171a3d54967c	1325376308	38.948089	-78.540296	71.65	71.65	True
8	2019-01-01 00:05:18	4922710831011201	fraud_Herzog Ltd	misc_pos	4.27	Heather	Chase	F	6888 Hicks Stream Suite 954	Manor	PA	15665	40.3359	-79.6607	1472	Public affairs consultant	1941-03-07	fc28024ce480f8ef21a32d64c93a29f5	1325376318	40.351813	-79.958146	4.27	4.27	True
9	2019-01-01 00:06:01	2720830304681674	fraud_Schoen, Kuphal and Nitzsche	grocery_pos	198.39	Melissa	Aguilar	F	21326 Taylor Squares Suite 708	Clarksville	TN	37040	36.5220	-87.3490	151785	Pathologist	1974-03-28	3b9014ea8fb80bd65de0b1463b00b00e	1325376361	37.179198	-87.485381	198.39	198.39	True

	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long	amt_month	amt_year	amt_month_shopping_net_spend	count_month_shopping_net	first_time_at_merchant
1852384	2020-12-31 23:57:18	30344654314976	fraud_Larkin, Stracke and Greenfelder	entertainment	46.71	Christine	Johnson	F	8011 Chapman Tunnel Apt. 568	Blairsden-Graeagle	CA	96103	39.8127	-120.6405	1725	Chartered legal executive (England and Wales)	1967-05-27	a7105564935ea3977dc61ff9ced3bf5e	1388534238	38.963543	-120.457121	7420.57	41336.21	1706.73	9.0	False
1852385	2020-12-31 23:57:50	3524574586339330	fraud_Heathcote, Yost and Kertzmann	shopping_net	29.56	Ashley	Cabrera	F	94225 Smith Springs Apt. 617	Vero Beach	FL	32960	27.6330	-80.4031	105638	Librarian, public	1986-05-07	9fc9f6f9be3182d519a61a119cf97199	1388534270	27.593881	-80.855092	14501.28	99329.66	2299.32	20.0	False
1852386	2020-12-31 23:57:56	341546199006537	fraud_Schmidt-Larkin	home	12.68	Mark	Brown	M	8580 Moore Cove	Wales	AK	99783	64.7556	-165.6723	145	Administrator, education	1939-11-09	a8310343c189e4a5b6316050d2d6b014	1388534276	65.623593	-165.186033	8706.23	67211.98	68.22	5.0	False
1852387	2020-12-31 23:58:04	501802953619	fraud_Pouros, Walker and Spencer	kids_pets	13.02	Robert	Flores	M	3277 Fields Meadows Apt. 790	Greenview	CA	96037	41.5403	-122.9366	308	Call centre manager	1958-09-20	bd7071fd5c9510a5594ee196368ac80e	1388534284	41.973127	-123.553032	9016.43	65502.89	1161.11	17.0	False
1852388	2020-12-31 23:58:34	3523843138706408	fraud_Prosacco, Kreiger and Kovacek	home	17.00	Grace	Williams	F	28812 Charles Mill Apt. 628	Plantersville	AL	36758	32.6176	-86.9475	1412	Drilling engineer	1970-11-20	6d04313bfe4b661b8ca2b6a499a320fe	1388534314	32.164145	-87.539669	13874.19	78212.66	1393.06	15.0	False
1852389	2020-12-31 23:59:07	30560609640617	fraud_Reilly and Sons	health_fitness	43.77	Michael	Olson	M	558 Michael Estates	Luray	MO	63453	40.4931	-91.8912	519	Town planner	1966-02-13	9b1f753c79894c9f4b71f04581835ada	1388534347	39.946837	-91.333331	11619.63	72134.23	1014.44	11.0	False
1852390	2020-12-31 23:59:09	3556613125071656	fraud_Hoppe-Parisian	kids_pets	111.84	Jose	Vasquez	M	572 Davis Mountains	Lake Jackson	TX	77566	29.0393	-95.4401	28739	Futures trader	1999-12-27	2090647dac2c89a1d86c514c427f5b91	1388534349	29.661049	-96.186633	15224.47	87115.43	3942.78	25.0	False
1852391	2020-12-31 23:59:15	6011724471098086	fraud_Rau-Robel	kids_pets	86.88	Ann	Lawson	F	144 Evans Islands Apt. 683	Burbank	WA	99323	46.1966	-118.9017	3684	Musician	1981-11-29	6c5b7c8add471975aa0fec023b2e8408	1388534355	46.658340	-119.715054	26233.12	165389.30	2978.91	29.0	False
1852392	2020-12-31 23:59:24	4079773899158	fraud_Breitenberg LLC	travel	7.99	Eric	Preston	M	7020 Doyle Stream Apt. 951	Mesa	ID	83643	44.6255	-116.4493	129	Cartographer	1965-12-15	14392d723bb7737606b2700ac791b7aa	1388534364	44.470525	-117.080888	11787.71	90698.65	768.69	17.0	False
1852393	2020-12-31 23:59:34	4170689372027579	fraud_Dare-Marvin	entertainment	38.13	Samuel	Frey	M	830 Myers Plaza Apt. 384	Edmond	OK	73034	35.6665	-97.4798	116001	Media buyer	1993-05-10	1765bb45b3aa3224b4cdcb6e7a96cee3	1388534374	36.210097	-97.036372	13871.45	116400.29	883.31	18.0	False

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Connector Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories